Problem Note 42554: The table.Model property does not work in the SAS® Financial Management Add-In API for Microsoft Excel
 |  |  |  |  |
The table.Model property in the SAS Financial Management Add-In API for the Microsoft Excel FMTable Class does not return the expected results.
When you submit Visual Basic (VBA) code to programmatically change the model that a SAS Financial Management table references, the table model does not correctly change.
For example, if your current table reads from the model 'Financial(Financial)' and you want to programmatically change the model to 'Budget(Budget)', you might submit the following VBA code to use the table.Model property in the SAS Financial Management Add-In API for the Microsoft Excel FMTable Class.
However, after you run this code, the table does not update properly. Specifically, you select Tables ► Properties and then select the Dimensions tab, the model changes to 'Financial(Budget)' instead of to 'Budget(Budget)'.
Click the Hot Fix tab in this note to access the hot fix for this issue.
For additional information about this problem, contact SAS Technical Support.
For more information about the SAS Financial Management Add-In API for Microsoft Excel, refer to the "SAS Solutions Services Customization Guide".
Note that when you are executing the code above, if you receive the compile error Error in loading DLL, you can register SASSESExcelAddin.dll as follows:
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe /codebase /tlb SASSESExcelAddin.dll
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||